CREATE TABLE [dbo].[tb_Users](
	[ID] [int] NOT NULL,
	[name] [nchar](20) NOT NULL,
	[hashedPassword] [binary](16) NOT NULL,
	[question] [nchar](50) NOT NULL,
	[hashedAnswer] [binary](16) NOT NULL,
	[email] [nchar](50) NULL,
	[sighWords] [nchar](100) NULL,
	[sex] [bit] NOT NULL,
	[msgNotSent] [xml] NULL,
	[msgGotRecordsXmlPath] [nchar](50) NOT NULL,
	[msgSentRecordsXmlPath] [nchar](50) NOT NULL,
	[friendsList] [xml] NULL,
	[address] [nchar](100) NOT NULL,
	[imgHeadUrl] [nchar](50) NULL,
	[regTime] [smalldatetime] NOT NULL,
	[logTime] [smalldatetime] NOT NULL,
	[lastLogTime] [int] NOT NULL,
	[ponts] [int] NOT NULL,
	[roles] [int] NOT NULL,
	[phone] [nchar](20) NULL,
 CONSTRAINT [PK_tb_Users] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
CREATE TABLE [dbo].[tb_articl](
	[articleID] [int] NOT NULL,
	[articleTitle] [nchar](50) NOT NULL,
	[articleUrl] [nchar](50) NOT NULL,
	[autherID] [nchar](20) NOT NULL,
	[createTime] [smalldatetime] NOT NULL,
	[clickTimes] [int] NOT NULL,
	[topic] [nchar](10) NOT NULL,
	[type] [nchar](10) NOT NULL,
	[up] [int] NOT NULL,
	[down] [int] NOT NULL,
 CONSTRAINT [PK_tb_articl] PRIMARY KEY CLUSTERED 
(
	[articleID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[tb_remark](
	[remarkID] [int] NOT NULL,
	[articlID] [int] NOT NULL,
	[autherID] [int] NOT NULL,
	[remarkTitle] [nchar](50) NOT NULL,
	[createTime] [smalldatetime] NOT NULL,
	[ReplyID] [int] NULL,
	[remarkUrl] [nchar](50) NOT NULL,
	[up] [int] NOT NULL,
	[down] [int] NOT NULL,
 CONSTRAINT [PK_tb_remark] PRIMARY KEY CLUSTERED 
(
	[remarkID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

